SHOW VARIABLES LIKE 'sql_mode'; -- enabled if STRICT_TRANS_TABLES is present SET GLOBAL sql_mode = ''; -- disables strict mode SET GLOBAL sql_mode = 'STRICT_TRANS_TABLES'; -- enables strict mode